ACS LLC
Enthusiast
ACS LLC
Enthusiast
Activity
‎Jul 10, 2024
12:25 AM
You can't read the info of a webp with CF, which was really disappointing for me. The solution for me was that I ran the site I needed to do this on, on Lucee instead, which worked exceptionally well and brought a few other advantages..
... View more
‎May 01, 2024
02:46 AM
Hi @Charlie Arehart As I moved the new platform to a server with Lucee I found that I didn't have to resolve the issue in ACF as it worked right out of the box with Lucee.
... View more
‎Apr 10, 2024
02:25 AM
I have to admit I can not remember what the outcome was at my side as it was almost 6 monhs ago. I searched threough the code I was working on and don't see me using the string approach. I also re-tried the code above (on CF2016) and it gave the right result. I have no idea what happened.
... View more
‎Feb 22, 2024
06:16 AM
My solution looks like it's going to be Lucee set to write sessions to file, and POSSIBLY adding a cookie with tokens, so if the user goes away for a long time, then I can use the cookie(s) to log them back in and create a new session. If I user goes away for a reasonable amount of time, then I don't think it's the end of the earth for their session to restart, especially if I can do it automatically (at least in my case). If they choose log out, I kill the session and also remove the cookies.
... View more
‎Feb 22, 2024
06:12 AM
oh, my bad on the link. Well they are all in here now 🙂 It's a little disappointing that Tomcat does not have this sorted out of the box, but at least when you know how, the fix is actually quite simple.
... View more
‎Feb 22, 2024
04:26 AM
I was not sure if I should post about Lucee in an Adobe forum 🙂 I actually had a couple of links, as I ended up contributing to a thread that had already addressed the issue. I did add a summary to both of the threads, but the one to look at is probably this one as it has a lot of info from others prior to me, and how I ended up with my fix https://dev.lucee.org/t/performance-issue-with-lucee-ajp-and-iis/13390/19 I am looking forward to getting updates again! I would have actually stuck with CF and purchased it if it was not so expensive.
... View more
‎Feb 22, 2024
01:53 AM
I've actually got another solution. as per the other thread I currently had open with the performance issues, I decided to try an install of Lucee. I didn't know that Lucee has the ability to write a session to file, so that would easily solve the problem. As it's also solved my speed issue and gets me away from the license costs of an upgrade of an old unsupported CF2016, I decided to go with Lucee. The only thing I now have to give some thought to is whether I want to give the user the ability to stay logged in, so, if they don't return for a while and the session actually expires, use a token or two in the cookies to log them back in and create a new session.
... View more
‎Feb 22, 2024
01:49 AM
Thanks for the input. It was several months ago I upgraded and I can't for the live of me remember if I managed to do it in-place, it looks like I did as my VM dashboard still thinks I am on Win2016. I have a recollation of some issues in upgrading but I can't remember what they were (I'd actually been very unwell with a serious condition and not long been out of hospital around the time so my memory is not great). I didn't try a local load of the pages, but yes, reinstalling in a cloned server did seem to fix the problem, suggesting something somewhere had changed. I wish could remember the series of events, but I am going to guess that I'd managed to install over the Win2016 and it changed something, then when I reinstalled it, it puts it back. If that is true then it's likely a matter of time before it happens again, mix in that CF2016 has not been updated for 3 years and was not designed for Win2022 and it does not seem like a great idea to keep it around any longer than I need to. With that being said, I decided the best thing is to upgrade. Choice being pay the big bucks for a CF license, or try (again) to get Lucee up and running. I went for the latter and after a similar performance issue managed to get it working fine (although it won't work on one of my sites but that's another story). So, I am going to forge ahead with Lucee and hope that will be the end of my trouble
... View more
‎Feb 21, 2024
05:15 AM
[CF2016 - Windows Server 2022 - IIS 10] I have a problem where if I replace a set of files, for instance 12 small CFM's and then I run one of them, it takes about 7 to 8 seconds for the page to load, then it's fine. This does not appear to impact HTML pages, just CFM. It's not database related, I saved the static results of a page, and saved that as a CFM so there was no database queries and it still did it. I never had a problem until I updated from Windows Server 2016 to 2022 I cloned the server and then installed a CF2023 trial so it made me think that perhaps CF2016 did not work well with Win2022/IIS 10. However, I then cloned it again, removed the CF2016 and reinstalled it, and it seems to be just fine. So the fix looks like I have to take down the production server, uninstall and reinstall, but before I do that, I was wondering if anybody has any thoughts on anything I might check that could fix this? Thanks
... View more
‎Feb 20, 2024
06:07 AM
Thanks Charlie, I shall roll up my sleeves and jump in feet first 🙂 I did look at a few Youtube videos but they were deep into the database side of things. Once I wrap up a couple of things I'll give it a go in a few days, what could possibly go wrong 😉
... View more
‎Feb 20, 2024
04:23 AM
Thanks for the reply Charlie. I've never used Redis and have zero knowledge of how it works. j2ee is already disabled so I'm good in that department I did find a link from a couple of years ago that you replied to https://coldfusion.adobe.com/2022/03/trying-redis-coldfusion-caching/ I see the person that wrote the article used it remotely on AWS. Ideally I'd install it locally on my own server. Reading it is says memory storage for sessions, so is it just another place to store them in memory and if that server was to be rebooted I'd be back to square one, or can it write to disk so that when I reboot the server it can pick up again? Are you aware of any documentation on how to install and config this on a CF server? Thanks
... View more
‎Feb 19, 2024
11:50 AM
(CF2016/Win 2022/IIS 10) I want my users to be able to stay logged in for a long period of time, however as Microsoft release it's updates every second Tuesday of the month, I like to make sure these are in place asap and this almost always requires a reboot. A reboot loses all of the sessions, so the users would have to log back in again. I believe (well according to my new friend ChatGPT) early versions of CF used to have an option write the session to a file so it could be recovered but now it's memory or Redis. I did find a thread in the forum regards editing of Tomcats config, but I was a little uncomfortable doing that. Does anybody have any solutions to this? My thought is that I'll write a big unique token (or two) into a cookie and stored in their database record, and when they return if they are logged out, use that to reauthenticate them and create a new logged in session, a "remember me" so it automatically logs them back in seemlessly. One downfall of this is that if they were in the middle of something, it's going to lose whatever that was and kick them to the start page of their dashboard. Second to this, I was just thinking, if the sessions are going into memory, does that mean that if I leave the length of the session too long that it's going to just eat up lots of memory over time as my user base grows? Appreciate any thoughts.
... View more
‎Nov 30, 2023
07:45 AM
Hi @BKBK I tried the code on my server, no graph https://www.aspirenet.com/chart.cfm It works locally. It charting something that has to be part of the install that perhaps I omitted when installing CF some years ago?
... View more
‎Nov 28, 2023
02:10 AM
No, I do have it running with a query, just for the example in this thread I slimmed it down. The code I posted is enough for me to see something is not working, on my local side I get an empty graph, on the server, the blank screen.
... View more
‎Nov 27, 2023
02:17 AM
1 Upvote
I have created a new thread https://community.adobe.com/t5/coldfusion-discussions/cfchart-producing-a-blank-screen/m-p/14259986#M196526
... View more
‎Nov 27, 2023
02:17 AM
I am displaying a chart using CFCHART. It works fine in local development on CF2016 Developer edition, however when I run the code on the server (also CF2016) I just get a blank white screen. Looking at the source code, everything appears to be there I looked at the CF Administrator and the "Charting" settings are the same. I don't see anything else that is related to the charts. I stripped it back to a very basic call for a chart with no data which will display an empty graph, this works on the local side (see attached screenshot), but not on the server, again, a white screen, no graph. Code below. <CFCHART title="My Graph" format="html" show3d="no" showlegend="yes" chartheight="400" chartwidth="500" labelFormat = "number" showborder="true" pieSliceStyle="sliced" sortXAxis = "yes"> <cfchartseries type="bar" dataLabelStyle="pattern" seriescolor="4199d1" valuecolumn="totalclicks" itemcolumn="click_country"> </cfchartseries> </cfchart> It's not throwing and error, the source looks okay, and I don't see any errors in the log either. Anybody have any ideas?
... View more
‎Nov 26, 2023
12:05 PM
I appear to have come across another problem with my CFCHART. On my local server (CF2016 - Developer edition), it works fine, the graph displays. However on the server also CF2016, nothing, just a blank white screen. I looked at the CF Administrator and the "Charting" settings are the same. I don't see anything else that is related to the charts. Anybody have any ideas? Thanks
... View more
‎Nov 16, 2023
09:21 AM
This is an issue I have on CF2016, but I've tried CF Fiddle and it's the same result on all versions, so I presume it's not a bug. I noticed that calculations were not rounding correctly, for example if the calculation gave a result of 7.875 and I used NumberFormat to round it to two decimal places, I would have expected it to round up to 7.88 After a lot of playing around, and a few conversations with ChatGTP 🙂 I hacked around and found something unusual, if I change the value to a string, within the NumberFormat, it works. Here is the code for the two tests with and without the ToString. Notice the different in rounding. Am I missing something? It gives me the right answer and I can't seem to break it, but it appears to be an odd way to go about things <CFOUTPUT> <b>Test 1</b> <br> Before rounding: #aff_payment# <br> After NumberFormat rounding: <b>#NumberFormat(aff_payment,"9999999.99")#</b> <br><br> <b>Test 2</b> <br> Before rounding: #aff_payment# <br> After NumberFormat rounding with ToString: <b>#NumberFormat(ToString(aff_payment),"9999999.99")#</b> </CFOUTPUT> Result Test 1 Before rounding: 7.875 After NumberFormat rounding: 7.87 Test 2 Before rounding: 7.875 After NumberFormat rounding with ToString: 7.88
... View more
‎Nov 12, 2023
12:02 PM
Thanks for the prompt feedback Charlie. This is good news. I expected or at least hoped that would be the answer, but I did worry, I was wondering if it loaded the template into memory but didn't execute it. In that case my code is all good. I should have really thought about it before I changed to work this way.
... View more
‎Nov 12, 2023
08:25 AM
I have some code that draws in multiple templates using CFINCLUDE I was originally redirecting to multiple pages with CFLOCATION but it worked out better if I could pull in those pages on an as needed basis with CFINCLUDE. The question I have is, if these CFINCLUDES are within CFIF statements and the condition is such that they do not need to be loaded, will the code be loaded into the CFM regardless of whether it is needed or not? I'd like to think that they are only accessed and loaded into CF if needed, especially since I've done the work now and this is an after thought/panic 🙂
... View more
‎Nov 02, 2023
12:29 PM
1 Upvote
I have reported it as a bug. Feel free to vote for it 🙂 https://tracker.adobe.com/#/view/CF-4219762
... View more
‎Nov 02, 2023
12:13 PM
oh yes, I forgot about the bug report, I'll take care of that, although I'm on CF2016, so won't see a bug fix appear in my version 😞
... View more
‎Nov 02, 2023
02:36 AM
Many thanks for taking the time to provide the solution. It's going to be a feature I use all the time, so rather than a temp tweak, in my situation I'm best removing the 3D which is a shame. I just set it to NO for 3D and it display fine. Shame, the 3D does look better, but I think I'm best not messing with the configs.
... View more
‎Oct 25, 2023
08:40 AM
(CF2016) I am using CFCHART and have a problem with the labels, making it difficult to read the data a) Text being in the same color as the bar b) Sitting too close to the bars Could anybody help me with either changing the colour (not sure that will help) and preferably moving the text further up so it sits on its own. Code and screenshot below. On another note, the defaul is a very nice looking blue gradient, but text was also light on pie and bar and extremely difficult to read, can anybody help with making it a gradient of the colour I have? Thanks <cfchart title="Revenue" format="html" show3d="yes" showlegend="yes" chartheight="400" chartwidth="500" labelFormat = "number" showborder="true" pieSliceStyle="sliced" sortXAxis = "yes"> <cfchartseries type="bar" dataLabelStyle="pattern" seriescolor="4199d1" QUERY="GetRevenue" valuecolumn="totalrevenue" itemcolumn="revenue_country"> </cfchartseries> </cfchart>
... View more
‎Oct 13, 2023
01:16 AM
As long as I put something within range I wouldn't have expected a round. I have it set at DECIMAL(8,2), if I put in 12.34 (manually) I get 12.34 . If I use CFQUERY to add 12.34 it also works, however if I used CFQUERYPARAM with the same value and I missed off the scale=2 then it appears something bad happens within CF. It's all good now I have the scale, I just need to make sure I never forget!
... View more
‎Oct 07, 2023
10:09 AM
I can answer my own question, but may as well leave the answer here I need to add scale = 2 <cfqueryparam value="#TheValueHere#" cfsqltype="CF_SQL_DECIMAL" scale="2">
... View more
‎Oct 07, 2023
10:02 AM
I am submitting values to MS SQL where I set the value in the CFQUERY using databasefield = <cfqueryparam value="#TheValueHere#" cfsqltype="CF_SQL_DECIMAL"> The database is set to DECIMAL(8,2) If I manually type in a value into the database such as 1.5 it works fine If I use the cfqueryparam above, and post 1.5, it rounds to 2, so that's not right I removed the cfqueryparam, and again submitted the valkue of 1.5 in the variable, and it worked fine, I end up with 1.5 in the database databasefield = #TheValueHere# Would anybody have any idea why using CFQUERYPARAM DECIMAL is causing it to round?
... View more
‎Sep 21, 2023
02:56 AM
The goal was to be able to nderstand if somebody had not just started a download but also completed it. I incorrectly thought that this was possible on WeTransfer, but after retesting it found that it's increasing the download count once you make a request for the file from the server, you don't even have to hit SAVE. I did read that IIS logs could help, with a code 200 or another code which I forget 20x to show if it was successful or not, but that turned out to be untrue, as soon as the browser gets that successful request, whether you hit save or not, you're getting the same success code. My need is not great enough, but I think that the only way to stand a chance of having something successfully do this would be to have a an app dedicated to this, and that was the only way to download the file, then use the app to report back to the server that it has successfully completed, unfortunately that is not something I'm going to be able to do with this task.
... View more
‎Sep 20, 2023
05:58 AM
Unfortunately my skill set is limiting me. I have a feeling that I'm just not clearly understanding Bens solution and where I should be looking to confirm a download completed
... View more
‎Sep 20, 2023
04:35 AM
Time flew by! I actually have more pressing need for this now, so picked it up again. I tried the code that Ben created but couldn't seem to get it to do what I needed. As soon as I clicked on the download link and the browser came up with the window to save the file it and the thank you for downloading message immediately appears in the client. Perhaps I am missing something https://www.bennadel.com/blog/2533-tracking-file-download-events-using-javascript-and-coldfusion.htm https://www.bennadel.com/blog/2533-tracking-file-download-events-using-javascript-and-coldfusion.htm
... View more